SD - Surya - Venkat - 2017-05-04 - 25881 - Spec - To make necessary changes to the E-invoicing for Mexico (Rizwan by 2017-05-30) #invoices #Mexico #ABAPEXTRACT #Quality #wipdev
SPECIFICATIONS
25881 - Spec - To make necessary changes to the E-invoicing for Mexico
Purpose
To make necessary changes to the E-invoicing for Mexico
Admin Info
| Purpose |
To make any necessary changes to the E-invoicing for Mexico |
| Requested By |
Rizwan Shah |
| Spec Created By |
Surya Basa |
| Spec Created Date |
05/17/2017 |
| Spec QA by |
Surya Basa |
| Objects |
ZISD_ETI_INVOICE_EXTRACT ZIFI_ETI_INVOICE_EXTRACT |
| Document Status |
WIP |
Estimates
| Sl.No |
Activity |
Estimation in Hours |
| 1 |
Research |
04 |
| 2 |
Documentation |
04 |
| 3 |
Development/ Config |
40 |
| 4 |
Unit test in DEV |
20 |
| 5 |
Unit test in QUA |
20 |
| 6 |
Other activity |
|
| TOTAL |
88 |
References
Prior Tickets
[Provide links of prior associated Spec / Break Fix BOSS document(s)]NA
Documents
[Attach any document(s) received for the requirement(s)]Copy of mapping proposal new era33.xlsx
EDICOM Functional Spec.pdf
Copy of mapping proposal CFDI 3.3 for fico debit and fico debits.xlsx
Copy of fico credits and debits.xlsx
Spec Changes
[List the changes made to program after the approval of the original requirement along with the Date on which the change request was received and the name of the initiator]
| Sl. |
Change Details |
Requested By |
Requested On |
Notes if any |
| 1 |
|
Rizwan Shah |
05/18/2017 |
Additional effort of 16hrs |
| 2 |
LINFAC - Catalog codes to replace Mat Gr-PH3 combination |
Rizwan Shah |
05/23/2017 |
Additional effort of 8hrs |
| 3 |
DOC_RELACIONADO |
Rizwan Shah |
05/26/2017 |
Additional effort of 6hrs |
| 4 |
CABFAC-PMTIS - if pay term is ZCBD then default PPD else PUE CABFAC-ZLSCH - if pay term is ZCBD then get the code linked to the EDICOM code for the payment method maintained in Ztable else default code 99 LINFAC and IMPLIN should appear one after another for each item unlike earlier where all items of one segment were followed by all items of other items |
Rizwan Shah |
06/20/2017 |
Additional effort of 6hrs |
| 5 |
CABFAC - change version to 3.3 (maintained in TVARVC), flip PMTIS with ZLSCH and vice versa and likewise IMPLIN - RETENCION_TIPOFACTOR with RETENCION_IMPORTE.1 |
Rizwan Shah |
06/30/2017 |
Additional effort of 1-2hrs |
| 6 |
IMPLIN - All RETENCION* segments including COMPLEMENTO_CONCP and PARTE_CLAVEPRODSERV to be blank |
Rizwan Shah |
07/13/2017 |
Additional effort of 1hr |
| 7 |
IMPLIN - Update TRASLADO_IMPORTE to populate tax amount instead of tax rate i.e., from VBRP-MWSBP |
Rizwan Shah |
07/17/2017 |
Additional effort of 1hr |
| 8 |
CABFAC-PMTIS - if pay term is ZCBD then default PUE with description, "Payment in one Exhibition" else PPD |
Rizwan Shah |
10/17/2017 |
Additional effort of 1hr |
| 9 |
DOC RELACIONADO - Ref document type should be of the document that is being created and not of the reference document unlike before (corresponding code for the document type to be pulled from table (ZMEXETI_BT) CABFAC-PMTIS = 99 if ZLSCH = PPD; PMTIS = C/T/0 etc.from cust mast if ZLSCH = PUE; ZTERM = Pay term desc from master data LINFAC-CLAVEUNIDAD - UoM should be picked from the MX Product catalog- should default to H87 and not from VBRP |
Beatriz/Rizwan |
10/26/2017 |
Additional effort of approx 4hrs |
| 10 |
Hello: As per the business request; we need to change some hard coded values we are placing in CFDis maps CABFAC.USOCFDI needs to be G01 instead of P01 for all the maps CABFAC.PMTIS needs to have 17 instead of 99 ----When issuing a returns , credit notes, debit notes, fico credit notes, fico debit notes the field -only for those types of documents,,,for invoices the rule that we have will continue to apply. |
Beatriz Arribas |
11/16/2017 |
Additional effort of approx 4hrs |
| 11 |
We said yesterday that CABFAC.USOCFDI will be G01 and that is correct.... For Credit Notes documents the CABFAC.USOCFDI needs to change to G02. I apologize for the changes but is information that we get from customers at last minute. |
Beatriz Arribas |
11/17/2017 |
|
| 12 |
FICO-IMPLIN Tax rate to be displayed as 0.1600000 instead of 16.00 |
Beatriz Arribas |
11/20/2017 |
|
| 13 |
FICO-Populate DOC RELACIONADO segment when a valid reference document is maintained in the Ref Doc field in F-32 |
Beatriz Arribas |
11/28/2017 |
|
| 14 |
Add TIPO RELACION code to FICO Debits and Credits |
Beatris Arribas |
11/30/2017 |
|
| 15 |
FI/CO - Fix to print extract even if text is entered in XBLNR w/o DOC RELACIONADO segment |
Beatriz Arribas |
01/08/2018 |
Post Go-Live change |
| 16 |
Credit Memo - Reference Invoice from VBAK-VGBEL (Issue-Return Credit Memo requests are created with reference to Invoice that don't actually have the Invoice Items but are different since business decided to accept returns even after the Invoice is fully paid and settled) |
Beatriz Arribas |
02/15/2018 |
|
| 17 |
IMPFAC - Tax rate (%) logic updated to work same as LINFAC |
Beatriz Arribas |
03/12/2018 |
Bug-fix |
| c_FormaPago |
Descripción |
| 01 |
Efectivo |
| 02 |
Cheque nominativo |
| 03 |
Transferencia electrónica de fondos |
| 04 |
Tarjeta de crédito |
| 05 |
Monedero electrónico |
| 06 |
Dinero electrónico |
| 08 |
Vales de despensa |
| 12 |
Dación en pago |
| 13 |
Pago por subrogación |
| 14 |
Pago por consignación |
| 15 |
Condonación |
| 17 |
Compensación |
| 23 |
Novación |
| 24 |
Confusión |
| 25 |
Remisión de deuda |
| 26 |
Prescripción o caducidad |
| 27 |
A satisfacción del acreedor |
| 28 |
Tarjeta de débito |
| 29 |
Tarjeta de servicios |
| 99 |
Por definir |
Functional Requirement
Purpose/WHY:
[Explain the purpose of the project and the reason why this requirement has come]Spec.pdf
In Scope:
[List the activities to be included in scope]Both the SD and FI ETI programs/extracts should be be changed to be in sync.
Out of Scope:
[Out of scope activities]
Solution Summary
[Discuss this section with Requester and get approval prior to beginning work]
- The extract program should be modified to include the changes specified in the spec document.
- Ztable should be created for maintaining the combination of Mat Gr - Gender - Catalog code.
- Ztable should be created for maintaining TIPO_RELACION codes with the combination of document types.
- Ztable should be created for maintaining EDICOM payment method codes mapped to NE payment method
Test Plan
[List test scenarios/cases to be executed here]| Test ID |
Test Scenario |
Expected Results |
| SD001 |
||
| SD002 |
Solution Details
[Provide complete technical details for configuration or programming here]
To be updated on completion of development and testing
Issues
[List Issues / Bugs identified in configuration or development]
An issue (rounding) unrelated to this project but for Mexico customer (Liverpool) using the same program has been analysed. Attached document contains the analysis.
Copy of liverpool Excel file invoice 94210641.xlsx
Liverpool issue has be dealt with at the business level - changing the calculation procedure (calculate taxes first and then discount to arrive at the net amount)